Coffee Bean Sales Dashboard

Created a dynamic Excel dashboard backed by SQL-driven analysis of over 200,000 coffee shop transactions to identify high-value customer behaviors and sales patterns. The project focused on visualizing loyalty program effectiveness and repeat purchase behavior to support targeted marketing strategies. The dashboard offered interactive breakdowns by region, product type, and time of day, allowing business stakeholders to easily pinpoint growth opportunities and loyalty-driven revenue.

Key features of the project include:

  • Identified that 70% of high-value purchases were made by loyalty card holders.
  • Visualized frequency of customer visits and average spend by segment.
  • Used SQL queries for cleaning, aggregating, and filtering transaction data prior to Excel modeling.
  • Included slicers, pivot charts, and DAX-style formulas to enhance interactivity.
  • Enabled filtering by month, daypart (morning/afternoon), and seasonal periods.

Key Insights

  • Loyalty members were 2.3 times more likely to make repeat high-value purchases.
  • Cross-selling patterns emerged most around pastries + premium coffee SKUs.
  • 58% of revenue came from morning sales, suggesting optimal window for promotions.
  • Female loyalty members aged 25 to 44 had the highest average ticket size.